2013-05-02 - 4674.1200 - Rel Notes - BI Reports Issues - Release 006 #BIReleases2013

Release Notes:

4674.1200 - BI Reports Issues - OSA100

Admin Info

Purpose
 To fix the issues in BIBO 4.0 Production server
Release No
 006
Submitted
 05-02-2013
Submitted by
 Praveen Guntuka
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BOBI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

Report Name

OSA100 - Open Orders by Date

BEx Query

ZMP_OOCON_Q010

NEC Crystal Reports Standards Check

1. OSA100 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA100 NEC CR checklist has been sent to NEC and also attached here for reference:

OSA100 NEC CR Standard Check List.xlsx

Summary Level Check

1. We have changed the format for Revenue and Summary fields in the Group Header section as well in the details section in OSA100 crystal report.
2. We have decreased the Decimal format for the Revenue and Summary values in respective sections.

Test Conducted

1. Verified all the sections whether the changes are applied or not.
2. Changed the Grouping option and checked for the changes.
3. Drill-down to lower level and checked the changes.
4. Ran the report in BI Launch pad and checked the changes.
5. For all the above scenarios test was successful.

Prior OSA100 Crystal Report was consisting of Fiscal Year and Fiscal Period Repository Functions. So we have implemented the Repository function logic at BEx query end and removed repository functions from Crystal Reports.

Dynamic Group 1:

Dynamic Grouping Parameter(1) and Group Name: Sales Org > Year > Period > Company > Customer > Order

Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 431
 431
 Pass
2
 Confirmed Quantity
 1230,265
 1230,265
 Pass
3
 Sales Org Currency
 11,600,656
 11,600,656
 Pass
4
 Corporate Currency
 11,600,656
 11,600,656
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 8,291
 8,291
 Pass
2
 Confirmed Quantity
 1,852,585
 1,852,585
 Pass
3
 Sales Org Currency
 15,338,077
 15,338,077
 Pass
4
 Corporate Currency
 23,239,247
 23,239,247
 Pass

Group 2 : APAC Sales > 2012
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 1
 1
 Pass
2
 Confirmed Quantity
 240
 240
 Pass
3
 Sales Org Currency
 26,829
 26,829
 Pass
4
 Corporate Currency
 3,456
 3,456
 Pass

Group 3 : Australia Sales > 2013 > July 2013
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 42
 42
 Pass
2
 Confirmed Quantity
 4,135
 4,135
 Pass
3
 Sales Org Currency
 74,906
 74,906
 Pass
4
 Corporate Currency
 78,096
 78,096
 Pass

Group 4 : Canada Sales > 2013 > April 2013 > 306 HIP HOP SK8 SHOP - 1007700
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 5
 5
 Pass
2
 Confirmed Quantity
 353
 353
 Pass
3
 Customer Currency
 6,376
 6,376
 Pass
4
 Sales Org Currency
 6,376
 6,376
 Pass
5
 Corporate Currency
 6,274
 6,274
 Pass

Group 5 : EMEA Sales > 2013 > April 2013 > 3 TRICKS SARL - 1002616 > 1293820
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 Order Date
 11/9/12
 11/9/12
 Pass
2
 First Ship
 4/9/13
 4/9/13
 Pass
3
 Last Ship
 4/9/13
 4/9/13
 Pass
4
 Cancel date
 5/9/13
 5/9/13
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 98
 98
 Pass
7
 Customer Currency
 1,424
 1,424
 Pass
8
 Sales Org Currency
 1,203
 1,203
 Pass
9
 Corporate Currency
 1,823
 1,823
 Pass

Group 6 : German Sales > 2013 > March 2013 > GALERIA KAUFHOF GMBH - 1004350 > 40004447 > 10315308
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 Material No.
 10315308
 10315308
 Pass
2
 Material
 SEASONAL BASIC BLK3930 NEYYAN BLK/SCARL
 SEASONAL BASIC BLK3930 NEYYAN BLK/SCARL
 Pass
3
 Collection
 SEAS BASIC(BLACK BA
 SEAS BASIC(BLACK BA
 Pass
4
 Order Status
 -
 -
 Pass
5
 Confirmed Quantity
 667
 667
 Pass
6
 Unit Price
 8
 8
 Pass
7
 Customer Currency
 5,336
 5,336
 Pass
8
 Sales Org Currency
 5,336
 5,336
 Pass
9
 Corporate Currency
 6,830
 24.45
 Pass

Dynamic Group 2:

Dynamic Grouping Parameter(2) and Group Name: Sales Org > Year > Product Group > Period > Order

Group 1 : Sales Organization Name : United States Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 35,261
 35,261
 Pass
2
 Confirmed Quantity
 11,339,726
 11,339,726
 Pass
3
 Sales Org Currency
 118,902,854
 118,902,854
 Pass
4
 Corporate Currency
 118,902,854
 118,902,854
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 8,291
 8,291
 Pass
2
 Confirmed Quantity
 1,852,585
 1,852,585
 Pass
3
 Sales Org Currency
 15,338,077
 15,338,077
 Pass
4
 Corporate Currency
 23,239,247
 23,239,247
 Pass

Group 2 : NEC Korea Sales > 2013
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 35
 35
 Pass
2
 Confirmed Quantity
 22,738
 22,738
 Pass
3
 Sales Org Currency
 451,080,790
 451,080,790
 Pass
4
 Corporate Currency
 405,973
 405,973
 Pass

Group 3 : Mexico Sales > 2013 > Headwear
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 135
 135
 Pass
2
 Confirmed Quantity
 278,699
 278,699
 Pass
3
 Sales Org Currency
 60,419,018
 60,419,018
 Pass
4
 Corporate Currency
 4,893,940
 4,893,940
 Pass

Group 4 : Latin America Sales > 2013 > Accessories > January 2013
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 1
 1
 Pass
2
 Confirmed Quantity
 192
 192
 Pass
3
 Customer Currency
 1,882
 1,882
 Pass
4
 Sales Org Currency
 1,882
 1,882
 Pass
5
 Corporate Currency
 1,882
 1,882
 Pass

Group 5 : German Sales > 2013 > Accessories > June 2013 > 1398687
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 Order Date
 2/14/13
 2/14/13
 Pass
2
 First Ship
 6/17/13
 6/17/13
 Pass
3
 Last Ship
 6/17/13
 6/17/13
 Pass
4
 Cancel date
 7/17/13
 7/17/13
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 30
 30
 Pass
7
 Customer Currency
 234
 234
 Pass
8
 Sales Org Currency
 234
 234
 Pass
9
 Corporate Currency
 300
 300
 Pass

Group 6 : Canada Sales > 2013 > Headwear > April 2013 > 1391473 > 10818751
SNo
 Test Case
 Value in CR
 Value in Production 4.0
 Pass/Fail
1
 Material No.
 10818751
 10818751
 Pass
2
 Material
 NFL13 SEASEA 5950 ONF DRAFT
 NFL13 SEASEA 5950 ONF DRAFT
 Pass
3
 Collection
 NFL DRAFT 59FIFTY
 NFL DRAFT 59FIFTY
 Pass
4
 Order Status
 O
 O
 Pass
5
 Confirmed Quantity
 1
 1
 Pass
6
 Unit Price
 19
 19
 Pass
7
 Customer Currency
 19
 19
 Pass
8
 Sales Org Currency
 19
 19
 Pass
9
 Corporate Currency
 18
 18
 Pass

Dynamic Group 3:

Dynamic Grouping Parameter(3) and Group Name: Sales Org > Year > Period > Product Group > Order

Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 431
 431
 Pass
2
 Confirmed Quantity
 1,230,265
 1,230,265
 Pass
3
 Customer Currency
 -
 -
 Pass
4
 Sales Org Currency
 11,600,656
 11,600,656
 Pass
5
 Corporate Currency
 11,600,656
 11,600,656
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 8,291
 8,291
 Pass
2
 Confirmed Quantity
 1,852,585
 1,852,585
 Pass
3
 Customer Currency
 -
 -
 Pass
4
 Sales Org Currency
 15,338,077
 15,338,077
 Pass
5
 Corporate Currency
 23,239,247
 23,239,247
 Pass

Group 2 : APAC Sales > 2012
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 1
 1
 Pass
2
 Confirmed Quantity
 240
 1,852,585
 Pass
3
 Customer Currency
 -
 -
 Pass
4
 Sales Org Currency
 26,829
 26,829
 Pass
5
 Corporate Currency
 3,456
 3,456
 Pass

Group 3 : Australia Sales > 2013 > August 2013
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 47
 47
 Pass
2
 Confirmed Quantity
 5,397
 5,397
 Pass
3
 Customer Currency
 -
 -
 Pass
4
 Sales Org Currency
 103,428
 103,428
 Pass
5
 Corporate Currency
 107,834
 107,834
 Pass

Group 4 : Canada Sales > 2013 > December 2013 > Headwear
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 No. of Orders
 6
 6
 Pass
2
 Confirmed Quantity
 1,695
 1,695
 Pass
3
 Customer Currency
 15,049
 15,049
 Pass
4
 Sales Org Currency
 15,049
 15,049
 Pass
5
 Corporate Currency
 14,808
 14,808
 Pass

Group 5 : German Sales > 2013 > March 2013 > Headwear > 40004447
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 Order Date
 3/14/13
 3/14/13
 Pass
2
 First Ship
 3/15/13
 3/15/13
 Pass
3
 Last Ship
 3/15/13
 3/15/13
 Pass
4
 Cancel date
 12/1/13
 12/1/13
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 800
 800
 Pass
7
 Customer Currency
 6,400
 6,400
 Pass
8
 Sales Org Currency
 6,400
 6,400
 Pass
9
 Corporate Currency
 8,191
 8,191
 Pass

Group 6 : Mexico Sales > 2013 > January 2013 > Headwear > 1345978 > 10622918
SNo
 Test Case
 Value in Edge
 Value in Production 4.0
 Pass/Fail
1
 Material No.
 10622918
 10622918
 Pass
2
 Material
 MX NFL ON FILED 5950 OAKRAI WHITE
 MX NFL ON FILED 5950 OAKRAI WHITE
 Pass
3
 Collection
 NFL On-Filed
 NFL On-Filed
 Pass
4
 Order Status
 O
 O
 Pass
5
 Confirmed Quantity
 1
 1
 Pass
6
 Unit Price
 245
 245
 Pass
7
 Customer Currency
 245
 245
 Pass
8
 Sales Org Currency
 245
 245
 Pass
9
 Corporate Currency
 20
 20
 Pass

Reference Document(Specification)

2013-04-18 - 4674.1200 - Spec - BI Reports Issues